Add a Estimate to the estimate table in the Body Shop database
Select a Customer:
---------
62 John Cane
63 Bob Knix
64 Adam Ginger
65 Tom Ramey
66 Jim Hughes
67 Noah Higman
68 Dave Tucker
Select a Automobile to update:
---------
Mechanic:
---------
1 Jimmy ToolBox
2 Grant EngineFixer
3 Eugene NeedaPart
Est Cost:
Date:
The sql for the insert
INSERT INTO Estimate VALUES (NULL, '', '', '', '')
Estimate Id
Mechanic Id
Car Id
Est Cost
Date
8
1
62
200
2023-04-25
9
3
67
100
2023-04-12
10
1
68
3333
2023-05-03
Back to the body shop page
Back to my home page